package com.contract.dao;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

import com.contract.pojo.Markinfo;
import com.contract.pojo.Tradinfo;



public interface ContractDao {
	
	/**
	 * 查询到期月
	 * @param connection
	 * @return
	 */
	public List queryExpMonth(Connection connection);
	
	/**
	 * 添加合约信息
	 * @param tradinfo
	 * @param connection
	 * @throws SQLException 
	 */
	public void addTadInfo(Tradinfo tradinfo,Connection connection) throws SQLException;
	
	/**
	 * 添加标的信息
	 * @param markinfo
	 * @param connection
	 * @throws SQLException 
	 */
	public void addMarkInfo(Markinfo markinfo,Connection connection) throws SQLException;
	
	/**
	 * 删除tradinfo中所有数据
	 * @throws SQLException 
	 */
	public void dropTradInfo(Connection connection) throws SQLException;
	
	/**
	 * 删除MarkInfo中所有数据
	 * @throws SQLException 
	 */
	public void dropMarkInfo(Connection connection) throws SQLException;

	/**
	 * 添加合约信息
	 * @param tradinfo
	 * @param connection
	 * @throws SQLException 
	 */
	public void addTadInfoAll(Tradinfo tradinfo,Connection connection) throws SQLException;
}
